<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_partjob`;");
CreateTable("CREATE TABLE `phpyun_partjob` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `name` varchar(30) NOT NULL DEFAULT '',
  `type` int(11) DEFAULT NULL,
  `sdate` int(11) DEFAULT NULL,
  `edate` int(11) DEFAULT NULL,
  `worktime` varchar(255) NOT NULL DEFAULT '',
  `number` int(11) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL,
  `salary` int(11) DEFAULT NULL,
  `salary_type` int(11) DEFAULT NULL,
  `billing_cycle` int(11) DEFAULT NULL,
  `provinceid` int(11) DEFAULT NULL,
  `cityid` int(11) DEFAULT NULL,
  `three_cityid` int(11) DEFAULT NULL,
  `address` varchar(100) NOT NULL DEFAULT '',
  `x` varchar(10) NOT NULL DEFAULT '',
  `y` varchar(10) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `deadline` int(11) DEFAULT NULL,
  `linkman` varchar(10) NOT NULL DEFAULT '',
  `linktel` varchar(15) NOT NULL DEFAULT '',
  `addtime` int(11) DEFAULT NULL,
  `r_status` int(2) DEFAULT '1',
  `state` int(2) DEFAULT '0',
  `lastupdate` int(11) DEFAULT NULL,
  `statusbody` varchar(200) NOT NULL DEFAULT '',
  `hits` int(11) DEFAULT '0',
  `com_name` varchar(30) NOT NULL DEFAULT '',
  `rec_time` int(11) DEFAULT '0',
  `did` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>